SUPPORT / SAMPLES & SAS NOTES
Problem Note 51025: Incorrect results might occur when you use the system options DIRECT_SQL= and READBUFF=
 |  |  |  |  |
Incorrect results might occur when you query a DB2 table via a LIBNAME engine and the following conditions exist:
- The LIBNAME option DIRECT_SQL= is set to NO.
- The LIBNAME option READBUFF= is set to a value greater than 1.
- The query contains a join of two or more DB2 tables based on a character variable.
- The WHERE clause contains an additional condition based on a character variable.
The following code illustrates one case that might result in no matches being found:
libname mydb2lib db2 direct_sql=no readbuff=5;
proc sql;
select * from mydb2lib.test1, mydb2lib.test2
where test1.var1=test2.var1 and
test2.var2 in ('00006','00999','00007');
quit;
Currently, there is no workaround other than to allow the query to be passed to DB2 by leaving DIRECT_SQL= out of the LIBNAME statement or to use the default setting of READBUFF=1.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS2M3 | 9.4 TS1M2 |